Basic Oracle SQL query statements
SQL> select DEPARTMENT_ID, DEPARTMENT_NAME from DEPARTMENTS where LOCATION_ID = 1700; DEPARTMENT_ID DEPARTMENT_NAME ---------------------------------------------------------------- 10 Administration 90 Executive 100 Finance 110 Accounting 120 Treasury 270 Payroll 6 rows selected. SQL>